package com.lvmama.pangolin.mybatis.mapper;

import java.util.List;

import com.lvmama.pangolin.entity.CommodityRel;
import org.apache.ibatis.annotations.Param;

import com.lvmama.pangolin.entity.link.TicketCommodityLink;

public interface RelevanceCommodityMapper {

	public int selectCountByCompanyCode(String companyCode);

	public int selectCounts(CommodityRel commodityRel);

	public void insertCommodityLink(TicketCommodityLink comLink);

	public void insertCommodityRel(CommodityRel commodityRel);

	public List<CommodityRel> queryByCommodityRel(CommodityRel commodityRel);

	public List<String> selectBusinessCodes();

	public List<String> selectCompanyCodes();

	public void deleteCommodityLink(TicketCommodityLink comLink);
	
	public List<TicketCommodityLink> viewCommodityLink(TicketCommodityLink comLink);
	
	public List<String> groupByCommodityId(@Param("productId")String productId,@Param("businessCode")String businessCode);
	
	public List<TicketCommodityLink> selectByCommProdComp(@Param("productId")String productId,@Param("commodityId")String commodityId,@Param("companyCode")String companyCode);
}
